Tabela NFZContrCodeDependencyType

Definicja tabeli NFZContrCodeDependencyType

Name

NFZContrCodeDependencyType

Code

NFZContrCodeDependencyType

Comment

Przechowuje definicje rodzaju zaleznosci pomiedzy kodem swiadczenia a dana (na chwile obecna: programy lekowe - ICD10, substancje czynne-ICD10)


Lista kolumn tabeli NFZContrCodeDependencyType

Name

Code

NFZContrCodeDependencyTypeID

NFZContrCodeDependencyTypeID

FullName

FullName

ShortName

ShortName

Code

Code

Description

Description

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna NFZContrCodeDependencyTypeID tabeli NFZContrCodeDependencyType

Definicja kolumny NFZContrCodeDependencyTypeID tabeli NFZContrCodeDependencyType

Name

NFZContrCodeDependencyTypeID

Code

NFZContrCodeDependencyTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FullName tabeli NFZContrCodeDependencyType

Definicja kolumny FullName tabeli NFZContrCodeDependencyType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna ShortName tabeli NFZContrCodeDependencyType

Definicja kolumny ShortName tabeli NFZContrCodeDependencyType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna Code tabeli NFZContrCodeDependencyType

Definicja kolumny Code tabeli NFZContrCodeDependencyType

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna Description tabeli NFZContrCodeDependencyType

Definicja kolumny Description tabeli NFZContrCodeDependencyType

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna StartDT tabeli NFZContrCodeDependencyType

Definicja kolumny StartDT tabeli NFZContrCodeDependencyType

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli NFZContrCodeDependencyType

Definicja kolumny StopDT tabeli NFZContrCodeDependencyType

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli NFZContrCodeDependencyType

Definicja kolumny Active tabeli NFZContrCodeDependencyType

Name

Active

Code

Active

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Lista kluczy tabeli NFZContrCodeDependencyType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli NFZContrCodeDependencyType

Definicja klucza Identifier_1 tabeli NFZContrCodeDependencyType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment